SDAC

TMSCompactConnectionOptions Properties

Properties of the TMSCompactConnectionOptions class.

For a complete list of the TMSCompactConnectionOptions class members, see the TMSCompactConnectionOptions Members topic.

Public

Name Description

DefaultSortType (inherited from TDAConnectionOptions)

Specifies the default type of local sorting for string fields. It is used when a sort type is not explicitly set after the field name in the TMemDataSet.IndexFieldNames property of a dataset.

DisconnectedMode (inherited from TDAConnectionOptions)

Opens a connection only when needed to perform a server call, and closes that connection after the operation is complete.

Encrypt (inherited from TCustomMSConnectionOptions)

Specifies if data should be encrypted before sending it over the network.

KeepDesignConnected (inherited from TDAConnectionOptions)

Prevents an application from establishing a connection at the time of startup.

LocalFailover (inherited from TDAConnectionOptions)

If True, the TCustomDAConnection.OnConnectionLost event occurs, and a failover operation can be performed after the connection is lost.

NumericType (inherited from TCustomMSConnectionOptions)

Specifies the format of storing and representing the NUMERIC (DECIMAL) fields for all TCustomMSDataSets associated with the given connection.

Provider (inherited from TCustomMSConnectionOptions)

Used to specify a provider from the list of supported providers.

QuotedIdentifier (inherited from TCustomMSConnectionOptions)

Causes Microsoft SQL Server to follow the SQL-92 rules for delimiting identifiers and literal strings with quotation marks.

UseWideMemos (inherited from TCustomMSConnectionOptions)

Manages field type creation for the NTEXT data type.

Published

Name Description

AllowImplicitConnect (inherited from TDAConnectionOptions)

Specifies whether to allow or not implicit connection opening.

AutoShrinkThreshold

Specifies the amount of free space in the database file before automatic shrink starts.

CompactVersion

Specifies which version of SQL Server Compact will be used.

DefaultLockEscalation

Specifies how many locks should be performed before trying escalation from row to page or from page to table.

DefaultLockTimeout

Specifies how much time in milliseconds a transaction will wait for a lock.

FlushInterval

Specifies the interval at which committed transactions are flushed to disk.

ForceCreateDatabase

Used to force TMSCompactConnection to create a new database before opening a connection, if the database is not exists.

LocaleIdentifier

Used to specify the preferable locale ID.

MaxBufferSize

Specifies how much memory SQL Server Compact Edition can use before flushing changes to disk.

MaxDatabaseSize

Specified maximum size of the main database file.

TempFileDirectory

Specifies the temp file directory.

TempFileMaxSize

Specified maximum size of the temporary database file.

See Also

© 1997-2025 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback